|
| Technical information |
| Error type | 256 |
| Error description | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY pinned desc,activity desc limit 0, 30' at line 3 |
| URL | asprunner.com/forums/forumtopics_list.php?category_alias=include/runnerJS/"' |
| Error file | C:\inetpub\wwwroot\asprunner.com\public_html\forums\connections\Connection.php |
| Error line | 668 |
| SQL query | SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( (categoryid=) ) ORDER BY pinned desc,activity desc limit 0, 30 |
| #0 |
connections\Connection.php:668 |
Connection->triggerError |
0. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY pinned desc,activity desc limit 0, 30' at line 3 |
| #1 |
connections\MySQLiConnection.php:160 |
MySQLiConnection->query |
0. SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( (categoryid=) ) ORDER BY pinned desc,activity desc limit 0, 30 |
| #2 |
connections\dbfunctions\MySQLFunctions.php:130 |
MySQLFunctions->limitedQuery |
0. MySQLiConnection
1. SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( (categoryid=) ) ORDER BY pinned desc,activity desc limit 0, 30
2. 0
3. 30
4. 1 |
| #3 |
connections\Connection.php:608 |
Connection->limitedQuery |
0. SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( (categoryid=) ) ORDER BY pinned desc,activity desc
1. 0
2. 30
3. 1 |
| #4 |
classes\datasource\table.php:647 |
DataSourceTable->getList |
0. DsCommand |
| #5 |
classes\listpage.php:2150 |
ListPage->getRecordset |
N/A |
| #6 |
classes\listpage.php:2302 |
ListPage->prepareForBuildPage |
N/A |
| #7 |
forumtopics_list.php:156 |
Global scope |
N/A |